﻿USE [QuanLyKTX]
GO
/****** Object:  Table [dbo].[tbl_VatDung]    Script Date: 05/06/2011 06:19:50 ******/
/****** Object:  Table [dbo].[tbl_VaiTro]    Script Date: 05/06/2011 06:19:50 ******/
INSERT [dbo].[tbl_VaiTro] ([MaVaiTro], [TenVaiTro]) VALUES (N'7d974fbe-92c7-41be-84bc-ae976ff60bc0', N'Quản trị hệ thống')
INSERT [dbo].[tbl_VaiTro] ([MaVaiTro], [TenVaiTro]) VALUES (N'3209e145-8dbc-4848-83d4-d847e2075e0c', N'Quản lý KTX')
/****** Object:  Table [dbo].[tbl_Truong]    Script Date: 05/06/2011 06:19:50 ******/
INSERT [dbo].[tbl_Truong] ([MaTruong], [TenTruong]) VALUES (N'CTT', N'Trường CĐ Nguyễn Tất Thành')
INSERT [dbo].[tbl_Truong] ([MaTruong], [TenTruong]) VALUES (N'CVN', N'Trường CĐ Văn Hoá Nghệ Thuật TPHCM')
INSERT [dbo].[tbl_Truong] ([MaTruong], [TenTruong]) VALUES (N'CVS', N'Trường CĐ Văn Hoá Nghệ Thuật và Du Lịch Sài Gòn')
INSERT [dbo].[tbl_Truong] ([MaTruong], [TenTruong]) VALUES (N'DHV', N'Trường ĐH DL Hùng Vương')
INSERT [dbo].[tbl_Truong] ([MaTruong], [TenTruong]) VALUES (N'DVH', N'Trường ĐH DL Văn Hiến')
INSERT [dbo].[tbl_Truong] ([MaTruong], [TenTruong]) VALUES (N'HUI', N'Trường Đại học Công nghiệp 4 TP.HCM')
INSERT [dbo].[tbl_Truong] ([MaTruong], [TenTruong]) VALUES (N'VLU', N'Trường ĐH Văn Lang')
/****** Object:  Table [dbo].[tbl_GiaoDien]    Script Date: 05/06/2011 06:19:50 ******/
INSERT [dbo].[tbl_GiaoDien] ([MaGiaoDien], [MoTa]) VALUES (N'frm_Contracts', N'Quản lý lập hợp đồng')
INSERT [dbo].[tbl_GiaoDien] ([MaGiaoDien], [MoTa]) VALUES (N'frm_EWBills', N'Quản lý Hóa đơn điện nước')
INSERT [dbo].[tbl_GiaoDien] ([MaGiaoDien], [MoTa]) VALUES (N'frm_EWRecords', N'Ghi chỉ số Điện - Nước')
INSERT [dbo].[tbl_GiaoDien] ([MaGiaoDien], [MoTa]) VALUES (N'frm_ListContracts', N'Quản lý Hợp đồng lưu')
INSERT [dbo].[tbl_GiaoDien] ([MaGiaoDien], [MoTa]) VALUES (N'frm_PriceEW', N'Quản lý thu tiền Điện - Nước')
INSERT [dbo].[tbl_GiaoDien] ([MaGiaoDien], [MoTa]) VALUES (N'frm_PriceRoom', N'Quản lý thu tiền phòng')
INSERT [dbo].[tbl_GiaoDien] ([MaGiaoDien], [MoTa]) VALUES (N'frm_RoomBill', N'Quản lý Hóa đơn phòng')
INSERT [dbo].[tbl_GiaoDien] ([MaGiaoDien], [MoTa]) VALUES (N'frm_Rooms', N'Quản lý phòng KTX')
INSERT [dbo].[tbl_GiaoDien] ([MaGiaoDien], [MoTa]) VALUES (N'frm_SortRoom', N'Quản lý xếp phòng')
/****** Object:  Table [dbo].[tbl_SinhVien]    Script Date: 05/06/2011 06:19:50 ******/
SET IDENTITY_INSERT [dbo].[tbl_SinhVien] ON
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (1, N'130700', N'DHV', N'07KT1 ', N'Nguyễn Thị ', N'Hồng ', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (2, N'', N'', N'', N'Trịnh Thị ', N'Vưởng', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (3, N'1094020139', N'DVH', N'K1003', N'Nguyễn Thanh ', N'Hằng ', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (4, N'310080061', N'CVS', N'K054QK2', N'Huỳnh Thị ', N'Hậu ', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (5, N'209060078', N'CVS', N'K042TK1', N'Nguyễn Thị Minh', N'Tâm', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (6, N'D103789', N'VLU', N'K16D01', N'Mai Lê Thùy', N'Dương', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (7, N'F106458', N'VLU', N'K16TC1', N'Nguyễn Thị', N'Lộc', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (8, N'F106458', N'VLU', N'K16TC1', N'Nguyễn Thị Như', N'Quỳnh', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (9, N'K106033', N'VLU', N'K16 T6', N'Lê Diễm ', N'My ', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (10, N'D10366', N'VLU', N'K16D1', N'Nguyễn Thị Phương', N'Thảo', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (11, N'F104027', N'VLU', N'K16TC1', N'Nguyễn Thị Tuyết', N'Xuân', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (12, N'K105523', N'VLU', N'K16KT1', N'Lê Trần ', N'Thảo ', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (13, N'Q105877', N'VLU', N'K16Q01', N'Nguyễn Thị Thanh', N'Thúy', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (14, N'D097630', N'VLU', N'k15D01', N'Nguyễn Thị Phương', N'Thảo', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (15, N'TH071KB', N'VLU', N'TH11DK3', N'Nguyễn Thị Hà', N'Trang', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (16, N'TH621KB', N'VLU', N'TH11DK2', N'Nguyễn thị Bích ', N'Ngân ', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (17, N'TH070KB', N'VLU', N'DK2 ', N'Trương  thị Kim  ', N'Ngân', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (18, N'C105795', N'VLU', N'K16C1 ', N'Trần Thị Tuyết', N'Minh', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (19, N'F106100', N'VLU', N'K16TC1', N'Nguyễn Phạm Bích', N'Trâm', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (20, N'C104186', N'VLU', N'K16C1', N'Nguyễn Ngọc', N'Khoa', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (21, N'C106475', N'VLU', N'K16C1', N'Trương Thị Thuỳ', N'Trang', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (22, N'C106475', N'VLU', N'K16C1', N'Trần Thị Thanh', N'Trúc', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (23, N'', N'', N'', N'Huỳnh Ngô Song', N'Phượng', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (24, N'C104378', N'VLU', N'K16C2', N'Nguyễn Trần Kim', N'Ngân', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (25, N'C103596', N'VLU', N'K16C01', N'Trần Thị Ly', N'Na', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (26, N'K105503', N'VLU', N'K16KT1', N'Vũ Thị Mai', N'Cúc', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (27, N'H106434', N'VLU', N'K16H01', N'Nguyễn Thị Hương', N'Nguyên', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (28, N'H106434', N'VLU', N'K16H01', N'Lê Thị Loan', N'Kiều', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (29, N'K104215', N'VLU', N'K16KT1', N'Lê Thị Ngọc', N'Châu', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (30, N'K097453', N'VLU', N'K15KT2', N'Phan Thị Tường', N'Vi', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (31, N'K103858', N'VLU', N'K16KT4', N'Phan Thị', N'Thúy', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (32, N'C902242', N'', N'', N'Nguyễn Thị Diễm ', N'Hồng ', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (33, N'D105649', N'VLU', N'K16D01', N'Nguyễn Thị', N'Vàng', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (34, N'Q101682', N'VLU', N'K16Q2 ', N'Đinh Thị Thanh', N'Trang', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (35, N'C106081', N'VLU', N'K16C', N'Huỳnh Thị Thúy', N'Ngân', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (36, N'Q102902', N'VLU', N'K16Q1', N'Ngô Thị Ngọc', N'Thi', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (37, N'Q102898', N'VLU', N'Q102898', N'Võ Trần Phương', N'Thảo', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (38, N'C106334', N'VLU', N'K16C1 ', N'Hồ Thuỵ Phương', N'Thảo', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (39, N'F102899', N'VLU', N'K16TC1', N'Phạm Ngọc Triều ', N'Tiên ', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (40, N'H104.785', N'VLU', N'K16NT2 ', N'Nguyễn Thảo ', N'Ly ', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (41, N'D102930', N'VLU', N'K16D', N'Phan Thị Kim', N'Kha', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (42, N'K105971', N'VLU', N'K16KT3', N'Trần Thị ', N'Tuyên ', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (43, N'M087979', N'VLU', N'K14M1 ', N'Ưng Thị Thúy ', N'Diễm ', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (44, N'Q103458', N'VLU', N'K16Q01', N'Đỗ Thị Minh', N'Uyên', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (45, N'Q106311', N'VLU', N'K16Q3', N'Lê Thị Lệ', N'Lâm', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (46, N'Q105536', N'VLU', N'K16Q4', N'Nguyễn thị', N'Hương', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (47, N'D103613', N'VLU', N'K16D4', N'Giang Thúc', N'Bình', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (48, N'D103993', N'VLU', N'K16D01', N'Đinh Thị Kim ', N'Ngân', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (49, N'K097808', N'VLU', N'K15KT5', N'Cao Vũ Yến ', N'Vi', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (50, N'K097808', N'VLU', N'K15KT5', N'Hoàng Mộng ', N'Quỳnh', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (51, N'K096762', N'VLU', N'K15KT5', N'Bùi Thị Thúy ', N'Phương ', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (52, N'F104937', N'VLU', N'K16TC1', N'Lương Thị', N'Thảo', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (53, N'C105500', N'VLU', N'K16C01', N'Nguyễn Lam', N'Giang', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (54, N'Q105172', N'VLU', N'K16Q5', N'Bùi Thanh', N'Thảo', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (55, N'F104550', N'VLU', N'K16TC2 ', N'Trần Thị Phương ', N'Hà ', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (56, N'D100053', N'VLU', N'K16D5', N'Hà Thị Lan', N'Hoa', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (57, N'D105455', N'VLU', N'K16D6B', N'Võ Thị Hồng', N'Loan', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (58, N'H104014', N'VLU', N'K16H1', N'Nguyễn Thị Minh', N'Hồng', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (59, N'F106663', N'VLU', N'K16TC2 ', N'Nguyễn Thoại', N'Anh', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (60, N'H106009', N'VLU', N'K16H01', N'Nguyễn Thị Thúy', N'Vi', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (61, N'D104878', N'VLU', N'K16D01', N'Đỗ Thị Diệu', N'Hiền', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (62, N'H104020', N'VLU', N'K16NT', N'Võ Thị cẩm', N'Hường', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (63, N'D103209', N'VLU', N'K16D01', N'Nguyễn Võ Thoại', N'Trân', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (64, N'D105995', N'VLU', N'K16D', N'Huỳnh Trần Phương ', N'Uyên ', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (65, N'D105740', N'VLU', N'K16D', N'Huỳnh Nguyễn Xuân', N'Khánh', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (66, N'K106722', N'VLU', N'K16KT16', N'Trần Thị Khánh', N'Ngọc', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (67, N'F105322', N'VLU', N'K16TC2 ', N'Đặng Thị Như', N'Hằng', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (68, N'C106050', N'VLU', N'K16C1', N'Nguyễn Châu Ái', N'Trân', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (69, N'F101967', N'VLU', N'K16TC1', N'Nguyễn Thị Yến', N'Nhi', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (70, N'K103395', N'VLU', N'K16KT1', N'Bùi Nguyễn Xuân', N'Nhi', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (71, N'C104720', N'VLU', N'K16C01', N'Nguyễn Thị Ngọc', N'Huyền', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (72, N'Q103950', N'VLU', N'K16Q01', N'Châu Thị Kim', N'Phụng', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (73, N'F105990', N'VLU', N'K16TC1', N'Nguyễn Thị Việt', N'Linh', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (74, N'H100065', N'VLU', N'K16H01', N'Nguyễn Ngọc Quỳnh', N'Trâm', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (75, N'K104324', N'VLU', N'K16KT1', N'Lương Thị Mỹ', N'Thịnh', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (76, N'H100797', N'VLU', N'K16H01', N'Nguyễn Thị Tuyết', N'Ngân', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (77, N'K102533', N'VLU', N'K16KT1', N'Phạm Thị Ngọc', N'Thùy', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (78, N'K105868', N'VLU', N'K16KT4 ', N'Trần Kim', N'Tước', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (79, N'', N'', N'', N'Hoàng Phương', N'Ngọc', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (80, N'Q106593', N'VLU', N'K16Q2 ', N'Chương Diễm', N'Hương', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (81, N'F106012', N'VLU', N'K16TC1', N'Lưu Thị Kim', N'Nhung', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (82, N'F102384', N'VLU', N'K16TC1', N'Nguyễn Thị Thu', N'Hương', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (83, N'F104053', N'VLU', N'K16TC1', N'Nguyễn Thị', N'Ny', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (84, N'K105525', N'VLU', N'K16KT5 ', N'Ngô Nguyễn Đoan', N'Thùy', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (85, N'', N'', N'', N'Nguyễn Thị Kim', N'Phượng', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (86, N'C104427', N'VLU', N'K16C01', N'Lê Thị Mỹ', N'Hòa', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (87, N'K100371', N'VLU', N'K16KT1', N'Nguyễn Thị', N'Mai', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (88, N'K104668', N'VLU', N'K16KT5 ', N'Phạm Thị Minh ', N'Ngọc ', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (89, N'F106145', N'VLU', N'K16TC1', N'Bùi Lê Thu', N'Hường', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (90, N'TH838KB ', N'VLU', N'TH11DL1', N'Lâm Thị Kiều', N'Ngân', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (91, N'D106223', N'VLU', N'K16D01', N'Trương Hoài', N'Thu', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (92, N'F105327', N'VLU', N'K16TC1', N'Nguyễn Thị Thanh', N'Trang', 0, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (93, N'F106555', N'VLU', N'K16TC1', N'Chu Mạnh', N'Tuấn', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (94, N'D105159', N'VLU', N'K16D1', N'Nguyễn Huỳnh Bảo', N'Huy', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (95, N'F105474', N'VLU', N'K16TC1', N'Nguyễn Duy', N'Khê', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (96, N'Q103017', N'VLU', N'K16Q01', N'Nguyễn Hoàng', N'Vũ', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (97, N'D106280', N'VLU', N'K16D01', N'Nguyễn Thiện', N'Quý', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (98, N'F105424', N'VLU', N'K16TC1', N'Trần  Vũ', N'Bách', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (99, N'Q103593', N'VLU', N'K16Q01', N'Vũ Duy', N'Thiện', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (100, N'K104958', N'VLU', N'K16KT1', N'Đặng Duy', N'An', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
GO
print 'Processed 100 total records'
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (101, N'', N'', N'', N'Nguyễn Huy Hoàng', N'Anh', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (102, N'F104569', N'VLU', N'K16TC8', N'Trần Minh', N'Tú', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (103, N'Q105337', N'VLU', N'K16Q4', N'Nguyễn Bao', N'Công', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (104, N'Q103338', N'VLU', N'K16Q04', N'Nguyễn Thanh', N'Bảo', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (105, N'A088592', N'VLU', N'K14A1', N'Dương An', N'Khương', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (106, N'C104147', N'VLU', N'K16C2', N'Nguyễn Quốc ', N'Dũng ', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (107, N'T074016', N'VLU', N'K13T1', N'Đặng Phú', N'Quốc', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (108, N'F105860', N'VLU', N'K16TC1', N'Phạm Bảo', N'Quốc ', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (109, N'C095360', N'VLU', N'K15C1', N'Nguyễn Võ ', N'Nam ', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (110, N'', N'', N'', N'Nguyễn Cương ', N'Trực ', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (111, N'10207141', N'HUI', N'CDKT12D', N'Bùi Quốc ', N'Hùng ', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (112, N'210070365', N'CVS', N'K052QL1', N'Lê Tuấn', N'Thanh', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (113, N'210020073', N'CVS', N'K052DV1 ', N'Bùi Văn ', N'Thưởng ', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (114, N'', N'CVS', N'', N'Đinh Quang', N'Nam', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (115, N'', N'CVS', N'', N'Văn Hữu', N'Phát', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (116, N'F106351', N'VLU', N'K16TC1', N'Phạm Văn ', N'Huấn ', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (117, N'Q104992', N'VLU', N'K16Q01', N'Nguyễn Đình', N'Huy', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (118, N'F106078', N'VLU', N'K16TC1', N'Nguyễn Ngọc', N'Sơn', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (119, N'2109004513', N'CTT', N'09CQT01', N'Nguyễn Khoa ', N'Nam ', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (120, N'TH821KB', N'VLU', N'TH11KT1', N'Phạm Viết', N'Đồng', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (121, N'K105466', N'VLU', N'K16KT5', N'Nguyễn Đức', N'An', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (122, N'TH789KB', N'VLU', N'TH11KT1', N'Võ Chí', N'Hiếu', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (123, N'X103859', N'VLU', N'K16X1', N'Võ Quốc', N'Thông', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (124, N'K107031', N'VLU', N'K16KT1', N'Nguyễn Lê Hà', N'Khánh', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (125, N'', N'', N'', N'Nguyễn Công', N'Phúc', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (126, N'Q106508', N'VLU', N'K16Q1', N'Trần Đức', N'Phú', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (127, N'K106483', N'VLU', N'K16KT1', N'Trần Hữu', N'Nhã ', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (128, N'C103219', N'VLU', N'K16C1 ', N'Nguyễn Nguyên ', N'Nam ', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (129, N'F093817', N'VLU', N'K15TC7 ', N'Nguyễn Hồ Ngọc', N'Huân ', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (130, N'C105670', N'VLU', N'K16C01', N'Lê Trần Triệu', N'Vĩ', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (131, N'F096347', N'VLU', N'K15TC7', N'Ngô Văn', N'Phú', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (132, N'P105019', N'VLU', N'K16PR2', N'Nguyễn Văn', N'Quyền', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (133, N'D104052', N'VLU', N'K16D1', N'Đinh Ngọc', N'Lâm', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (134, N'H105640', N'VLU', N'K16H1', N'Nguyễn Văn', N'Dũng', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (135, N'H100802', N'VLU', N'K16H1', N'Nguyễn Hữu', N'Nguyễn', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (136, N'F100017', N'VLU', N'K16TC', N'Trương Đức', N'Trung', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (137, N'Q100374', N'VLU', N'K16Q2', N'Lê Hoài', N'Nam', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (138, N'D104062', N'VLU', N'K16D5', N'Nguyễn Vinh ', N'Quang ', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (139, N'', N'VLU', N'K15TC6 ', N'Dương Thái ', N'Cầm ', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
INSERT [dbo].[tbl_SinhVien] ([ID], [MaSinhVien], [MaTruong], [MaLop], [Ho], [Ten], [GioiTinh], [NgaySinh], [SoCMND], [NoiCap], [NgayCap], [DiaChi], [SoDienThoai], [SoDienThoaiCN], [Email], [KhoaTaiKhoan]) VALUES (140, N'C106399', N'VLU', N'K16C1', N'Nguyễn Văn', N'Ngọc', 1, NULL, N'', N'', NULL, N'', N'', N'', N'', 0)
SET IDENTITY_INSERT [dbo].[tbl_SinhVien] OFF
/****** Object:  Table [dbo].[tbl_Phong]    Script Date: 05/06/2011 06:19:50 ******/
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.01', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.02', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.03', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.04', 0, 7, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.05', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.06', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.07', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.08', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.09', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.10', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.11', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.12', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.13', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.14', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.15', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.16', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.17', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.18', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.19', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.20', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.21', 0, 4, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.22', 0, 4, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.23', 0, 4, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.24', 0, 2, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.25', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.26', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.27', 0, 2, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.28', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.29', 0, 5, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.30', 0, 4, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.31', 0, 4, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.32', 0, 5, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.33', 0, 4, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.34', 0, 7, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.35', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.36', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.37', 0, 5, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.38', 0, 4, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.39', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.40', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.41', 0, 5, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.42', 0, 4, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.43', 0, 4, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.44', 0, 3, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.45', 0, 4, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.46', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.47', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.48', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.49', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.50', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.51', 0, 5, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.52', 0, 4, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.53', 0, 2, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.54', 0, 4, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.55', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.56', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.57', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.58', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.59', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.60', 0, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.61', 1, 3, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.62', 1, 3, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.63', 1, 4, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.64', 1, 4, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.65', 1, 3, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.66', 1, 4, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.67', 1, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.68', 1, 4, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.69', 1, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.70', 1, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.71', 1, 3, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.72', 1, 4, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.73', 1, 4, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.74', 1, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.75', 1, 4, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.76', 1, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.77', 1, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.78', 1, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.79', 1, 8, 8)
INSERT [dbo].[tbl_Phong] ([SoPhong], [LoaiPhong], [SoGiuongTrong], [TongSoGiuong]) VALUES (N'P.80', 1, 8, 8)
/****** Object:  Table [dbo].[tbl_PhieuThu]    Script Date: 05/06/2011 06:19:50 ******/
/****** Object:  Table [dbo].[tbl_PhanQuyen]    Script Date: 05/06/2011 06:19:50 ******/
INSERT [dbo].[tbl_PhanQuyen] ([MaVaiTro], [MaGiaoDien], [ThucThi], [Xem]) VALUES (N'3209e145-8dbc-4848-83d4-d847e2075e0c', N'frm_Contracts', 0, 1)
INSERT [dbo].[tbl_PhanQuyen] ([MaVaiTro], [MaGiaoDien], [ThucThi], [Xem]) VALUES (N'3209e145-8dbc-4848-83d4-d847e2075e0c', N'frm_EWBills', 0, 1)
INSERT [dbo].[tbl_PhanQuyen] ([MaVaiTro], [MaGiaoDien], [ThucThi], [Xem]) VALUES (N'3209e145-8dbc-4848-83d4-d847e2075e0c', N'frm_EWRecords', 0, 1)
INSERT [dbo].[tbl_PhanQuyen] ([MaVaiTro], [MaGiaoDien], [ThucThi], [Xem]) VALUES (N'3209e145-8dbc-4848-83d4-d847e2075e0c', N'frm_ListContracts', 0, 1)
INSERT [dbo].[tbl_PhanQuyen] ([MaVaiTro], [MaGiaoDien], [ThucThi], [Xem]) VALUES (N'3209e145-8dbc-4848-83d4-d847e2075e0c', N'frm_PriceEW', 0, 1)
INSERT [dbo].[tbl_PhanQuyen] ([MaVaiTro], [MaGiaoDien], [ThucThi], [Xem]) VALUES (N'3209e145-8dbc-4848-83d4-d847e2075e0c', N'frm_PriceRoom', 0, 1)
INSERT [dbo].[tbl_PhanQuyen] ([MaVaiTro], [MaGiaoDien], [ThucThi], [Xem]) VALUES (N'3209e145-8dbc-4848-83d4-d847e2075e0c', N'frm_RoomBill', 0, 1)
INSERT [dbo].[tbl_PhanQuyen] ([MaVaiTro], [MaGiaoDien], [ThucThi], [Xem]) VALUES (N'3209e145-8dbc-4848-83d4-d847e2075e0c', N'frm_Rooms', 0, 1)
INSERT [dbo].[tbl_PhanQuyen] ([MaVaiTro], [MaGiaoDien], [ThucThi], [Xem]) VALUES (N'3209e145-8dbc-4848-83d4-d847e2075e0c', N'frm_SortRoom', 0, 1)
/****** Object:  Table [dbo].[tbl_Lop]    Script Date: 05/06/2011 06:19:50 ******/
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14A', N'AX')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14C', N'CO')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14C1', N'CO')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14C2', N'CO')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14C3', N'CO')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14D', N'DL')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14D01', N'DL')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14D02', N'DL')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14D03', N'DL')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14H', N'MC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14H-DH', N'MC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14H-NT', N'MC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14H-TD', N'MC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14H-TT', N'MC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14KT', N'KT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14KT1', N'KT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14KT2', N'KT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14KT3', N'KT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14KT4', N'KT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14M', N'MT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14M01', N'MT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14M02', N'MT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14N', N'NN')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14N01', N'NN')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14N02', N'NN')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14NL1', N'DA')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14PR', N'PR')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14PR1', N'PR')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14PR2', N'PR')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14PR3', N'PR')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14Q', N'QT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14Q1', N'QT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14Q2', N'QT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14Q3', N'QT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14Q4', N'QT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14Q5', N'QT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14S', N'SH')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14S01', N'SH')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14S02', N'SH')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14T', N'TH')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14T01', N'TH')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14T02', N'TH')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14TC', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14TC1', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14TC2', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14TC3', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14TC4', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14TC5', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14TC6', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14TC7', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14TC8', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K14X', N'AX')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15A', N'AX')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15A01', N'AX')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15A02', N'AX')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15A03', N'AX')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15C', N'CO')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15C01', N'CO')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15C02', N'CO')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15D', N'DL')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15D01', N'DL')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15D02', N'DL')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15D03', N'DL')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15D04', N'DL')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15H-DH', N'MC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15H-NT', N'MC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15H-TD', N'MC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15H-TT', N'MC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15KT1', N'KT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15KT2', N'KT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15KT3', N'KT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15KT4', N'KT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15KT5', N'KT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15KT6', N'KT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15M', N'MT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15M01', N'MT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15M02', N'MT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15N', N'NN')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15N01', N'NN')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15N02', N'NN')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15NL1', N'DA')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15PR', N'PR')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15PR1', N'PR')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15PR2', N'PR')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15PR3', N'PR')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15Q1', N'QT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15Q2', N'QT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15Q3', N'QT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15Q4', N'QT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15Q5', N'QT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15Q6', N'QT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15Q7', N'QT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15S', N'SH')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15S01', N'SH')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15T', N'TH')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15T01', N'TH')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15T02', N'TH')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15TC', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15TC1', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15TC10', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15TC2', N'FB')
GO
print 'Processed 100 total records'
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15TC3', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15TC4', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15TC5', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15TC6', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15TC7', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15TC8', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15TC9', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K15X', N'AX')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16A', N'AX')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16A01', N'AX')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16A02', N'AX')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16A03', N'AX')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16C01', N'CO')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16C02', N'CO')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16D01', N'DL')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16D02', N'DL')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16D03', N'DL')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16D04', N'DL')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16D05', N'DL')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16D06A', N'DL')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16D06B', N'DL')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16DH-1', N'MC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16DH-2', N'MC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16DH-3', N'MC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16DH-4', N'MC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16H', N'MC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16KT1', N'KT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16KT2', N'KT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16KT3', N'KT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16KT4', N'KT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16KT5', N'KT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16KT6', N'KT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16M1', N'MT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16N1', N'NN')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16N2', N'NN')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16N3', N'NN')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16NL1', N'DA')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16NT-1', N'MC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16NT-2', N'MC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16NT-3', N'MC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16NT-4', N'MC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16NT-5', N'MC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16PR1', N'PR')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16PR2', N'PR')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16Q01', N'QT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16Q02', N'QT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16Q03', N'QT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16Q04', N'QT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16Q05', N'QT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16Q06', N'QT')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16S', N'SH')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16T01', N'TH')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16T02', N'TH')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16TC1', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16TC2', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16TC3', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16TC4', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16TC5', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16TC6', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16TC7', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16TC8', N'FB')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16TD', N'MC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16TT', N'MC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16X', N'AX')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16X01', N'AX')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16X02', N'AX')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'K16X03', N'AX')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'TH10', N'TC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'TH10BV1', N'TC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'TH10DK', N'TC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'TH10DL1', N'TC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'TH10DL2', N'TC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'TH10DL3', N'TC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'TH10KT1', N'TC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'TH10KT2', N'TC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'TH10QT1', N'TC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'TH10TH1', N'TC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'TH11DD1', N'TC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'TH11DL1', N'TC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'TH11KT1', N'TC')
INSERT [dbo].[tbl_Lop] ([MaLop], [MaKhoa]) VALUES (N'TH11TH1', N'TC')
/****** Object:  Table [dbo].[tbl_LoaiHopDong]    Script Date: 05/06/2011 06:19:50 ******/
INSERT [dbo].[tbl_LoaiHopDong] ([MaLoaiHD], [TenLoaiHD]) VALUES (1, N'Hợp đồng cá nhân')
INSERT [dbo].[tbl_LoaiHopDong] ([MaLoaiHD], [TenLoaiHD]) VALUES (2, N'Hợp đồng bao phòng')
/****** Object:  Table [dbo].[tbl_Khoa]    Script Date: 05/06/2011 06:19:50 ******/
INSERT [dbo].[tbl_Khoa] ([MaKhoa], [MaTruong], [TenKhoa], [IsVocation]) VALUES (N'AX', N'VLU', N'Khoa Kiến trúc Xây dựng', 0)
INSERT [dbo].[tbl_Khoa] ([MaKhoa], [MaTruong], [TenKhoa], [IsVocation]) VALUES (N'CO', N'VLU', N'Khoa Thương Mại', 0)
INSERT [dbo].[tbl_Khoa] ([MaKhoa], [MaTruong], [TenKhoa], [IsVocation]) VALUES (N'DA', N'VLU', N'Khoa Điện lạnh', 0)
INSERT [dbo].[tbl_Khoa] ([MaKhoa], [MaTruong], [TenKhoa], [IsVocation]) VALUES (N'DL', N'VLU', N'Khoa Du lịch', 0)
INSERT [dbo].[tbl_Khoa] ([MaKhoa], [MaTruong], [TenKhoa], [IsVocation]) VALUES (N'FB', N'VLU', N'Khoa Tài chính Ngân hàng', 0)
INSERT [dbo].[tbl_Khoa] ([MaKhoa], [MaTruong], [TenKhoa], [IsVocation]) VALUES (N'KT', N'VLU', N'Khoa Kế toán - Kiểm toán', 0)
INSERT [dbo].[tbl_Khoa] ([MaKhoa], [MaTruong], [TenKhoa], [IsVocation]) VALUES (N'MC', N'VLU', N'Khoa Mỹ thuật Công nghiệp', 0)
INSERT [dbo].[tbl_Khoa] ([MaKhoa], [MaTruong], [TenKhoa], [IsVocation]) VALUES (N'MT', N'VLU', N'Khoa Công nghệ & Quản lý Môi trường', 0)
INSERT [dbo].[tbl_Khoa] ([MaKhoa], [MaTruong], [TenKhoa], [IsVocation]) VALUES (N'NN', N'VLU', N'Khoa Ngoại ngữ', 0)
INSERT [dbo].[tbl_Khoa] ([MaKhoa], [MaTruong], [TenKhoa], [IsVocation]) VALUES (N'PR', N'VLU', N'Khoa Quan hệ Công chúng & Truyền thông', 0)
INSERT [dbo].[tbl_Khoa] ([MaKhoa], [MaTruong], [TenKhoa], [IsVocation]) VALUES (N'QT', N'VLU', N'Khoa Quản trị Kinh doanh', 0)
INSERT [dbo].[tbl_Khoa] ([MaKhoa], [MaTruong], [TenKhoa], [IsVocation]) VALUES (N'SH', N'VLU', N'Khoa Công nghệ Sinh học', 0)
INSERT [dbo].[tbl_Khoa] ([MaKhoa], [MaTruong], [TenKhoa], [IsVocation]) VALUES (N'TC', N'VLU', N'Ban Trung học Chuyên nghiệp', 1)
INSERT [dbo].[tbl_Khoa] ([MaKhoa], [MaTruong], [TenKhoa], [IsVocation]) VALUES (N'TH', N'VLU', N'Khoa Công nghệ Thông tin', 0)
/****** Object:  Table [dbo].[tbl_HopDong]    Script Date: 05/06/2011 06:19:50 ******/
/****** Object:  Table [dbo].[tbl_NoiThat]    Script Date: 05/06/2011 06:19:50 ******/
/****** Object:  Table [dbo].[tbl_NhanVien]    Script Date: 05/06/2011 06:19:50 ******/
INSERT [dbo].[tbl_NhanVien] ([MaNhanVien], [MaVaiTro], [TenDangNhap], [MatKhau], [Ho], [Ten], [DiaChi], [NgaySinh], [SoDienThoai], [Email], [QuanTriHeThong], [NguoiTao], [NgayTao], [NguoiCapNhat], [NgayCapNhap], [KhoaTaiKhoan]) VALUES (N'75bd080b-8128-4ba8-a329-0e8c396fa096', N'7d974fbe-92c7-41be-84bc-ae976ff60bc0', N'sa', N'ZWfqC6zrnXwJf6SeOJ9y8g==', N'Nguyễn Ảnh', N'Nhân', N'46 Tân Ký Tân Quý, P. Tây Thạnh, Q. Tân Phú, TP. Hồ Chí Minh', CAST(0x94090B00 AS Date), N'0903341784', N'nguyenanhnhan@vanlanguni.edu.vn', 1, NULL, NULL, NULL, NULL, 0)
/****** Object:  Table [dbo].[tbl_XepPhong]    Script Date: 05/06/2011 06:19:50 ******/
SET IDENTITY_INSERT [dbo].[tbl_XepPhong] ON
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (156, N'P.04', 1, CAST(0xEF330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (157, N'P.04', 2, CAST(0x02340B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (158, N'P.04', 3, CAST(0xF7330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (159, N'P.04', 4, CAST(0xFD330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (160, N'P.04', 5, CAST(0x22340B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (163, N'P.21', 6, CAST(0x4F330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (164, N'P.21', 7, CAST(0x51330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (165, N'P.21', 8, CAST(0x51330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (166, N'P.21', 9, CAST(0x55330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (167, N'P.22', 10, CAST(0x50330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (168, N'P.22', 11, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (169, N'P.22', 12, CAST(0x4F330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (170, N'P.22', 13, CAST(0x4F330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (171, N'P.23', 14, CAST(0xEA330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (172, N'P.23', 15, CAST(0xB3330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (173, N'P.23', 16, CAST(0xEC330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (174, N'P.23', 17, CAST(0xEC330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (175, N'P.24', 18, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (176, N'P.24', 19, CAST(0x51330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (177, N'P.24', 20, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (178, N'P.24', 21, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (179, N'P.24', 22, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (180, N'P.24', 23, CAST(0x24340B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (181, N'P.27', 24, CAST(0xE2310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (182, N'P.27', 25, CAST(0x50330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (183, N'P.27', 26, CAST(0x50330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (184, N'P.27', 27, CAST(0x50330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (185, N'P.27', 28, CAST(0x50330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (186, N'P.27', 29, CAST(0x50330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (187, N'P.29', 30, CAST(0xFD330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (188, N'P.29', 31, CAST(0xFD330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (189, N'P.29', 32, CAST(0xFD330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (190, N'P.30', 33, CAST(0xE9310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (191, N'P.30', 34, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (192, N'P.30', 35, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (193, N'P.30', 36, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (194, N'P.31', 37, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (195, N'P.31', 38, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (196, N'P.31', 39, CAST(0xED330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (197, N'P.31', 40, CAST(0xF3330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (198, N'P.32', 41, CAST(0xE5310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (199, N'P.32', 42, CAST(0xE7310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (200, N'P.32', 43, CAST(0x01340B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (201, N'P.33', 44, CAST(0xE4310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (202, N'P.33', 45, CAST(0xE2310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (203, N'P.33', 46, CAST(0x20320B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (204, N'P.33', 47, CAST(0x2B320B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (205, N'P.34', 48, CAST(0xBF340B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (206, N'P.37', 49, CAST(0xED330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (207, N'P.37', 50, CAST(0xED330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (208, N'P.37', 51, CAST(0xED330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (209, N'P.38', 52, CAST(0x50330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (210, N'P.38', 53, CAST(0x50330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (211, N'P.38', 54, CAST(0x50330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (212, N'P.38', 55, CAST(0x4D330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (213, N'P.41', 56, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (214, N'P.41', 58, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (215, N'P.41', 57, CAST(0x4F330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (216, N'P.42', 59, CAST(0x4F330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (217, N'P.42', 60, CAST(0x4F330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (218, N'P.42', 61, CAST(0x4F330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (219, N'P.42', 62, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (220, N'P.43', 63, CAST(0xE3310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (221, N'P.43', 64, CAST(0x4F330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (222, N'P.43', 65, CAST(0x4F330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (223, N'P.43', 66, CAST(0x4F330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (224, N'P.44', 67, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (225, N'P.44', 68, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (226, N'P.44', 69, CAST(0x4F330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (227, N'P.44', 70, CAST(0x4F330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (228, N'P.44', 71, CAST(0xE3310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (229, N'P.45', 72, CAST(0xE1310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (230, N'P.45', 74, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (231, N'P.45', 75, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (232, N'P.45', 73, CAST(0xE3310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (233, N'P.51', 76, CAST(0x4F330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (234, N'P.51', 77, CAST(0x4F330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (235, N'P.51', 78, CAST(0xE5310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (236, N'P.52', 79, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (237, N'P.52', 80, CAST(0xE2310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (238, N'P.52', 81, CAST(0xE3310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (239, N'P.52', 82, CAST(0xE1310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (240, N'P.53', 83, CAST(0xE2310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (241, N'P.53', 84, CAST(0xE2310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (242, N'P.53', 86, CAST(0x4F330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (243, N'P.53', 87, CAST(0x4F330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (244, N'P.53', 85, CAST(0x3D320B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (245, N'P.53', 88, CAST(0x50330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (246, N'P.54', 89, CAST(0x50330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (247, N'P.54', 90, CAST(0x50330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (248, N'P.54', 92, CAST(0x50330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (249, N'P.54', 91, CAST(0xE2310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (250, N'P.61', 93, CAST(0x50330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (251, N'P.61', 94, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (252, N'P.61', 95, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (253, N'P.61', 96, CAST(0x51330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (254, N'P.61', 97, CAST(0x13340B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (255, N'P.62', 98, CAST(0x50330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (256, N'P.62', 99, CAST(0x51330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (257, N'P.62', 100, CAST(0xE2310B00 AS Date), NULL)
GO
print 'Processed 100 total records'
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (258, N'P.62', 101, CAST(0x1B340B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (259, N'P.62', 102, CAST(0xED330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (260, N'P.63', 103, CAST(0x25320B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (261, N'P.63', 104, CAST(0xEE320B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (262, N'P.63', 105, CAST(0xE7330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (263, N'P.63', 106, CAST(0xE6330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (264, N'P.64', 107, CAST(0xF8310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (265, N'P.64', 108, CAST(0xEA330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (266, N'P.64', 109, CAST(0xE5330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (267, N'P.64', 110, CAST(0xE5330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (268, N'P.65', 111, CAST(0xF5330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (269, N'P.65', 112, CAST(0x16340B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (270, N'P.65', 113, CAST(0xFD330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (271, N'P.65', 114, CAST(0x19340B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (272, N'P.65', 115, CAST(0x16340B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (273, N'P.66', 116, CAST(0x51330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (274, N'P.66', 117, CAST(0x51330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (275, N'P.66', 118, CAST(0x51330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (276, N'P.66', 119, CAST(0x03340B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (277, N'P.68', 120, CAST(0x51330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (278, N'P.68', 123, CAST(0xE4310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (279, N'P.68', 121, CAST(0xE2310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (280, N'P.68', 122, CAST(0xE5310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (281, N'P.71', 124, CAST(0xE3310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (282, N'P.71', 125, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (283, N'P.71', 126, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (284, N'P.71', 127, CAST(0x4E330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (285, N'P.71', 128, CAST(0xB4330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (286, N'P.72', 129, CAST(0xE4310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (287, N'P.72', 130, CAST(0xE4310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (288, N'P.72', 131, CAST(0x05320B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (289, N'P.72', 132, CAST(0xAC330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (291, N'P.73', 133, CAST(0x3F320B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (292, N'P.73', 134, CAST(0xE2310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (293, N'P.73', 135, CAST(0xE1310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (294, N'P.73', 136, CAST(0xE3310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (295, N'P.75', 137, CAST(0xE1310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (296, N'P.75', 140, CAST(0xE1310B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (297, N'P.75', 138, CAST(0xB4330B00 AS Date), NULL)
INSERT [dbo].[tbl_XepPhong] ([MaXepPhong], [SoPhong], [ID], [NgayVao], [NgayRa]) VALUES (298, N'P.75', 139, CAST(0xEC330B00 AS Date), NULL)
SET IDENTITY_INSERT [dbo].[tbl_XepPhong] OFF
/****** Object:  Table [dbo].[tbl_HoaDonDienNuoc]    Script Date: 05/06/2011 06:19:50 ******/
INSERT [dbo].[tbl_HoaDonDienNuoc] ([MaHoaDon], [SoPhong], [TuNgay], [DenNgay], [KyThang], [Nam], [CSDienDau], [CSDienCuoi], [CSNuocDau], [CSNuocCuoi], [DonGiaDien], [DonGiaNuoc], [GhiChu], [NgayXuat]) VALUES (N'3e425a6e-a370-4d06-a53a-d71c2d3fe38a', N'P.01', CAST(0xEF330B00 AS Date), CAST(0x0A340B00 AS Date), 2, N'2011', N'1', N'10', N'1', N'20', 1433.0000, 2000.0000, N'', CAST(0x2E340B00 AS Date))
INSERT [dbo].[tbl_HoaDonDienNuoc] ([MaHoaDon], [SoPhong], [TuNgay], [DenNgay], [KyThang], [Nam], [CSDienDau], [CSDienCuoi], [CSNuocDau], [CSNuocCuoi], [DonGiaDien], [DonGiaNuoc], [GhiChu], [NgayXuat]) VALUES (N'40134687-ca00-416e-8317-e6b1312ade02', N'P.01', CAST(0x0A340B00 AS Date), CAST(0x29340B00 AS Date), 3, N'2011', N'10', N'20', N'20', N'40', 1433.0000, 2000.0000, N'', CAST(0x2E340B00 AS Date))
/****** Object:  Table [dbo].[tbl_ChiSoDienNuoc]    Script Date: 05/06/2011 06:19:50 ******/
INSERT [dbo].[tbl_ChiSoDienNuoc] ([MaChiSo], [SoPhong], [ChiSoDien], [ChiSoNuoc], [KyThang], [Nam], [Loai], [NgayGhi], [GhiChu]) VALUES (N'02b7f7b8-35ba-444e-838a-109100ff4845', N'P.01', 10, 20, 2, N'2011', 1, CAST(0x0A340B00 AS Date), N'')
INSERT [dbo].[tbl_ChiSoDienNuoc] ([MaChiSo], [SoPhong], [ChiSoDien], [ChiSoNuoc], [KyThang], [Nam], [Loai], [NgayGhi], [GhiChu]) VALUES (N'7484036c-e39d-4d53-83fa-50ce84335ea5', N'P.01', 1, 1, 2, N'2011', 0, CAST(0xEF330B00 AS Date), N'')
INSERT [dbo].[tbl_ChiSoDienNuoc] ([MaChiSo], [SoPhong], [ChiSoDien], [ChiSoNuoc], [KyThang], [Nam], [Loai], [NgayGhi], [GhiChu]) VALUES (N'78f653aa-dfbe-430f-88dd-b277c606b409', N'P.01', 20, 40, 3, N'2011', 1, CAST(0x29340B00 AS Date), N'')
/****** Object:  Table [dbo].[tbl_CauHinhApDungPhi]    Script Date: 05/06/2011 06:19:50 ******/
INSERT [dbo].[tbl_CauHinhApDungPhi] ([NgayCauHinh], [MaLoaiHD], [DonGiaDien], [DonGiaNuoc], [TienPhong], [TienPhongVL], [PhiBanDau], [PhiBanDauVL], [NgayApDung], [KichHoat]) VALUES (CAST(0x28340B00 AS Date), 1, 1433.0000, 2000.0000, 300000.0000, 200000.0000, 600000.0000, 600000.0000, CAST(0x13340B00 AS Date), 0)
INSERT [dbo].[tbl_CauHinhApDungPhi] ([NgayCauHinh], [MaLoaiHD], [DonGiaDien], [DonGiaNuoc], [TienPhong], [TienPhongVL], [PhiBanDau], [PhiBanDauVL], [NgayApDung], [KichHoat]) VALUES (CAST(0x28340B00 AS Date), 2, 1433.0000, 2000.0000, 1800000.0000, 1200000.0000, 3600000.0000, 2400000.0000, CAST(0x13340B00 AS Date), 1)
INSERT [dbo].[tbl_CauHinhApDungPhi] ([NgayCauHinh], [MaLoaiHD], [DonGiaDien], [DonGiaNuoc], [TienPhong], [TienPhongVL], [PhiBanDau], [PhiBanDauVL], [NgayApDung], [KichHoat]) VALUES (CAST(0x2C340B00 AS Date), 1, 1600.0000, 2000.0000, 300000.0000, 200000.0000, 600000.0000, 600000.0000, CAST(0x2C340B00 AS Date), 1)
/****** Object:  Table [dbo].[tbl_TienCoc]    Script Date: 05/06/2011 06:19:50 ******/
/****** Object:  Table [dbo].[tbl_PhuLucHopDong]    Script Date: 05/06/2011 06:19:50 ******/
/****** Object:  Table [dbo].[tbl_HoaDonPhong]    Script Date: 05/06/2011 06:19:50 ******/
